Libris Britannia 4/science library(b).zip/science library(b)/MEDICAL/H301.ZIP/DENTL-A4.EXE/DENTIST.ACS/MERGE.DOC

Text File | 1992-04-08 | 26KB | 632 lines

                          Import or Output Data:

                                  Import:
            Import a 12 or 13 field ASCII "comma delimited" file.
                           see options '8' or '9'

                                  Output:
    WordStar[TM]/MailMerge[TM]/WordPerfect[TM]/Microsoft [TM] Word 4.0
              dBASE III [TM]/SBT [TM]/SourceMate [TM] Output
                       Basica/Output Sequential File

                                 Overview:
                               Options 1 - 7

Thesσ option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼  WordPerfect[TM]¼  o≥ ì
dBAS┼á  II╔ [TM▌ datß filσ usinτ thσ datß froφ you≥ Patient/dBAS┼ II╔ file« ì
Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ .DEF'¼ '.SFº o≥ '.DBF'.

Iµá useΣá witΦá Wordstar[TM]¼á  thσ .DA╘ filσ caε bσá useΣá t∩á prin⌠á forφ  ì
letter≤ iε  MailMerge[TM]«á   Al∞ characte≥ field≤ arσ  trimmeΣ oµ trailinτ ì
blank≤á t∩á accommodatσ  you≥ forφ letters«á    Alonτ witΦ thi≤ datßá file¼  ì
thσ  Wordsta≥  optioε  create≤  thσ beginninτ oµ  you≥ forφ lette≥ anΣ put≤ ì
i⌠á  iεá  ßá  filσ endinτ  iε  thσ │ letter≤á '.DEFºá (containinτá al∞á thσ ì
MailMerge[TM▌  command≤ yo⌡ neeΣ a⌠ thσ star⌠ oµ ß forφ letter)«

Iµá  useΣá  witΦ WordPerfect[TM]¼á  thσ .S╞ filσ i≤ thσá 'Secondar∙á  Fileº  ì
tha⌠á  WordPerfec⌠á  use≤á  fo≥á mergσá letters¼áá   wherσá eacΦá fielΣá i≤  ì
delimiteΣ  witΦ CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]

Iµá useΣá witΦá dBAS┼á II╔ [TM]¼á  thσ '.DBFº filσá forma⌠á i≤á becominτá ß  ì
standarΣá datß  filσ  forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥á  thei≥  ì
respectivσ datß impor⌠ function.

Wheε useΣ witΦ Microsof⌠ [Reg«  TM▌ WorΣ 4.0¼  thσ '.DATº filσ contain≤ thσ ì
datß o≥ record≤ tha⌠ thσ WorΣ 4.░ mergσ documen⌠ requires«



Thesσá option≤  wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iε you≥ patient filσ ì
t∩ aε externa∞ tex⌠ filσ tha⌠ can¼á  iε turn¼á  bσ useΣ b∙ ß worΣ processo≥ ì
t∩ creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.

Based  on your selection criteria,  if any,  the program will  output  these ì
fields:
     Sex ID, First name, Greeting, Last name, Company Name, Address1/2
              City, State, Zip, Zip4, Phone number, Comments


                               ==============
                               |  OPTION 1: |
                               ==============

                             Selection Process:
èAt option 1, you can input up to 7 search criteria as the basis for
your word processor merge file:

             Last Name, First Name, Company, City, State, Zip,
                               and Comments.

Yo⌡á  caεá  selec⌠á whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤á t∩á  bσá  selecteΣ   ì
tha⌠á  havσá  al∞á oµá criterißá iε ever∙ recorΣá o≥á selec⌠á ou⌠á  record≤  ì
regardles≤á  oµ thσ  numbe≥ oµ  matche≤ madσ pe≥ record¼á   a≤ lonτá a≤á a⌠  ì
leas⌠ onσ matcΦ i≤ madσ iε an∙ onσ recorΣ tha⌠ i≤ selected.

Truσ  [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠  t∩
bσ  selected«   Falsσ  [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε  ß
recorΣ i⌠ wil∞ bσ selected.



                         Search Criteria Selection:
                                 Option 1:

Yo⌡á caεá ente≥á an∙á word¼á   phrase¼á  o≥ codσ oεá whicΦá t∩á  basσá you≥ ì
selection«á  Iµ  lef⌠ blank¼á   al∞ record≤ wil∞ bσ selecteΣ out«    Iµ yo⌡ ì
makσá aε  entr∙ here¼á   thσ  prograφ wil∞ searcΦ througΦ thσ patien⌠á filσ  ì
anΣ  selec⌠  ou⌠ onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.

[Notσá tha⌠á yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤á entereΣá herσ  ì
anΣá al∞á   record≤á wil∞á bσ pulleΣ whicΦ havσ an∙ onσá oµá theφá  o≥á an∙  ì
combinatioε oµ them]

                               ==============
                               |  OPTION 2: |
                               ==============
                2)  Output records to Wordstar/Mailmerge[TM]
              [outputs into a 12 field, comma delimited file]

                             fields outputted:
             SEX, FNAME, GREETING, LNAME, PROSPECT, ADDRESS1,
                 ADDRESS2, CITY, STATE, ZIP, ZIP4, PHONE-1

This  option is used to get data from the patient file and output it  to  a ì
file  that  can be used by WordStar/MailMerge[TM].   This  file can also  be ì
used by BASIC and other languages and products.  In short,  any product that ì
accepts  "comma delimited" files for input may accept the  file  created  by ì
this option.

Froφá thσ WordSta≥ option¼á  yo⌡ wil∞ creatσ  tw∩ files«á   Thσ firs⌠á filσ ì
namσá end≤á  iε  .DE╞ anΣ i≤ ß filσ tha⌠ caε bσ turneΣ int∩ ßá forφá lette≥  ì
jus⌠á  b∙á callinτ  i⌠ u≡ iε WordSta≥ anΣ matchinτ i⌠ t∩ you≥ forφá letter«   ì
I⌠á alread∙á contain≤  al∞ oµ thσ command≤ needeΣ b∙ WordSta≥ t∩á reaΣá thσ  ì
Patient/dBAS┼ II╔ datß filσ (.DAT).

The other  file is the .DAT file,  which contains all data that you want  to ì
read  into WordStar.   It is formatted sequential file,  with all fields  in ì
quotes and separated by commas.
è
                               ==============
                               |  OPTION 3: |
                               ==============

                   3)  Output records to WordPerfect[TM]
            [outputs into a 14 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
                    ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2

The  .SF  file  is  the 'Secondary File' that  WordPerfect  uses  for  merge ì
letters,   where each field is delimited with CONTROL-R,  and each record is ì
delimited with CONTROL-E.]

Be  sure to retrieve the 'Secondary File' into WordPerfect,  at which  time ì
WordPerfect will insert its printer codes.  Then, while inside WordPerfect, ì
save the file under that same name.   At this point,  the 'Secondary  File' ì
will be usable for purposes of mail merging.

                           [Similar to option B]

                               ==============
                               |  OPTION 4: |
                               ==============

               4)  Output records to dBASE III [Registered TM]


With  option  4,  the '.DBF' file format is becoming a  standard  data  file ì
format  that many other programs are using for their respective data  import ì
function.

Once  you assign a name to the dBASE III [TM] file you are  outputting,  the ì
structure of that file is:

Field  Field Name  Type       Width    Dec
    1  SEX         Character     19
    2  FNAME       Character     20
    3  GREETING    Character     20
    4  LNAME       Character     20
    5  PROSPECT    Character     40
    6  ADDRESS1    Character     30
    7  ADDRESS2    Character     30
    8  CITY        Character     30
    9  STATE       Character      2
   10  ZIP         Numeric        5  < numeric representation of Zip codes
   11  ZIP4        Numeric        4  < numeric representation of Zip+4 codes
   12  ZIP_CH      Character      5  < character representation of Zip codes
   13  ZIP4_CH     Character      4  < character representation of Zip+4 codes
   14  PHONE_1     Character     13
   15  COMMENT1    Character     60
   16  COMMENT2    Character     60
   17  CATEGORY    Numeric        8è   18  PRIORITY    Numeric        4
   19  REFERBY     Character     30
   20  FIRST_DATE  Character     10
   21  TITLE       Character     35

** Total **                     450


Thσá numeriπ zi≡ codσ field≤ dro≡ leadinτ zeros¼á whilσ thσ characte≥á one≤ ì
adΣ theφ back.

Iµá yo⌡á invokσ thσ Selectioε Criteriß Men⌡ iε optioε 1¼á theε thσá prograφ ì
wil∞ asδ yo⌡ iµ yo⌡ wisΦ t∩ outpu⌠ froφ thσ Patien⌠ o≥ Activit∙á file«á  Iµ ì
yo⌡ selec⌠ thσ latter¼ theε thi≤ filσ i≤ outputted:


Field  Field Name  Type       Width    Dec
    1  SEX         Character     19
    2  FNAME       Character     20
    3  LNAME       Character     20
    4  PROSPECT    Character     40
    5  ADDRESS1    Character     30
    6  ADDRESS2    Character     30
    7  CITY        Character     30
    8  STATE       Character      2
    9  ZIP         Numeric        5
   10  ZIP_CH      Character      5
   11  PHONE_1     Character     13
   12  COMMENT1    Character    200
   13  CATEGORY    Numeric        8
   1┤  CALLBAC╦    Characte≥     1░
   15  FIRST_DATE  Character     10
** Total **                     443


Observσ tha⌠ ß callbacδ datσ appear≤ iµ an∙ onl∙ iµ yo⌡ havσ entereΣ ß datσ ì
othe≥á thaεá '01/01/1901ºá iε thσ Callbacδ fielΣ oµá thσá activit∙á record«   ì
Wheneve≥á thσá prograφá see≤á '01/01/1901º iε thσá callbacδá fielΣá oµá thσ ì
activity¼á theεá i⌠ assume≤ tha⌠ yo⌡ havσ n∩ callbacδ anΣ doe≤á no⌠á outpu⌠ ì
anythinτ int∩ fielΣ 1┤ above«

Notσá als∩á tha⌠ FIRST_DAT┼ i≤ thσ datσ wheε thi≤ recorΣ wa≤ firs⌠á entereΣ ì
int∩ thσ program.


                               ==============
                               |  OPTION 5: |
                               ==============
               5)  Output records to Microsoft [TM] Word 4.0

              [outputs into a 12 field, comma delimited file]

                             fields outputted:
             SEX, FNAME, GREETING, LNAME, PROSPECT, ADDRESS1,
                 ADDRESS2, CITY, STATE, ZIP, ZIP4, PHONE1è

This  option is used to get data from the patient file and output it to  a ì
data file that can be used by the merge feature in Word 4.0..

Your Word 4.0 letter will contain merge variables of the form:

                                  <<SEX>>
                                 <<FNAME>>
                               <<GREETING>>
                                 <<LNAME>>
                               <<PROSPECT>>

and  so on.   These merge variables are identified in the '.DEF' or  header ì
file created by the program.   These symbols,  "<<" and ">>", are formed by ì
holding down the <ALT> key and typing 174 or 175.


At  the  top of your Word 4.0 letter,  you will have this command  (if  you ì
select 'TEST' as the file name for outputting your data in option 5):

<<DATA TEST.DEF, TEST.DAT>>

This  tells Word 4.0 to look into TEST.DEF for the header or identification ì
of fields used; and to pull in TEST.DAT for the data.

TEST.DAT is a 'comma delimited, ASCII file'.  It contains all data that you ì
want  to read into Word 4.0.   It is formatted sequential  file,  with  all ì
fields in quotes and separated by commas.


                               ==============
                               |  OPTION 6: |
                               ==============

This option will append records directly to the SBT [TM] customer file.


                               ==============
                               |  OPTION 7: |
                               ==============

This  option  will append records directly to the SourceMate [TM]  customer ì
file.

                               ==============
                               |  OPTION 8: |
                               ==============

                        Import data from ASCII file:

   Create an ASCII "comma delimited" file with these 12 fields:

   First name     <== up to 20 characters
   Last name      <== up to 20 charactersè   Company name   <== up to 40 characters
   Address 1      <== up to 30 characters, first line of address
   Address 2      <== up to 30 characters, 2nd line, if any, such as
                      'Suite 214'
   City           <== up to 30 characters
   State          <== two character state, if U.S.A.; else leave blank
   Zip            <== U.S.A. Zip code, 5 characters
   Zip4           <== U.S.A. Supplemental Zip code, 4 characters
   Phone          <== 13 character, if .U.S.A. or Canada. Must be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
   Comment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'

   Option  8 will import from an ASCII file  named:  'AIMPORT.TXT'.   Make ì
   sure that your file has that name.

   Observe below one record in the ASCII "comma delimited" format:


   "John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
      "Suite 101","Dallas","TX","75229","0234","[phone]","SIC=4303",""


   Observe  that  "Suite  101"  would normally follow after  "11056  Shady ì
   Trail"  on  one continuous line.   Here the record is broken  into  two ì
   lines only for purposes of showing you how it looks.

                               ==============
                               |  OPTION 9: |
                               ==============

                        Import data from ASCII file:

   Create an ASCII "comma delimited" file with these 13 fields:

   First name     <== up to 20 characters
   Last name      <== up to 20 characters
   Company name   <== up to 40 characters
   Address 1      <== up to 30 characters, first line of address
   Address 2      <== up to 30 characters, 2nd line, if any, such as
                      'Suite 214'
   City           <== up to 30 characters
   State          <== two character state, if U.S.A.; else leave blank
   Zip            <== U.S.A. Zip code, 5 characters
   Zip4           <== U.S.A. Supplemental Zip code, 4 characters
   Phone          <== 13 character, if .U.S.A. or Canada. Must be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
   Comment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'
   Revenue/Expense<== Any value entered here will cause a corresponding
                      first record in the Activity file to be created.

   Option  9 will import from an ASCII file  named:  'AIMPORT.TXT'.   Make ìè   sure that your file has that name.

   Observe below one record in the ASCII "comma delimited" format:


   "John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
      "Suite 101","Dallas","TX","75229","0234","[phone]",
      "SIC=4303","Mr.","5412.43"


   Observe  that  "Suite 101"  would normally follow  after  "11056  Shady ì
   Trail"  on  one continuous line.   Here the record is broken  into  two ì
   lines  only  for  purposes of showing you how it looks.   You  are  not ì
   required  to enter a value for the Revenue/Expense field.   If you  do, ì
   then  the  program will create a corresponding record in  the  activity ì
   file.

   One application of this would be if you are bringing in records from an ì
   Accounts Receivable file, with an amount owed for each debtor.


                               ==============
                               |  OPTION A: |
                               ==============

        "A)  Select date range [works with #2,3,4,5 B and D only]"


Option  A is to change the start or stop date on the options to  Import  or ì
Output Data.  It defaults to these dates:

   START DATE :'01/01/1901'
   STOP DATE  :'12/12/2999'

Note  that this date range selection will work only with selections #2,  3, ì
4, and 5 on this menu.



                               ==============
                               |  OPTION B: |
                               ==============

                   B)  Output records to WordPerfect[TM]
            [outputs into a 17 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
       ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2,CATEGORY,PRIORITY,REFERBY

The  .SF  file  is the 'Secondary File' that  WordPerfect  uses  for  merge ì
letters,   where each field is delimited with CONTROL-R, and each record is ì
delimited with CONTROL-E.]

Be  sure to retrieve the 'Secondary File' into WordPerfect,  at which  time ìèWordPerfect will insert its printer codes.  Then, while inside WordPerfect, ì
save the file under that same name.   At this point,  the 'Secondary  File' ì
will be usable for purposes of mail merging.

                           [Similar to option 3]



                               ==============
                               |  OPTION C: |
                               ==============


                       Import data from ASCII file:

       Create an ASCII "comma delimited" file with these 24 fields:
                   [Bring data into Patient Detail File]

   First name     <== up to 20 characters
   Last name      <== up to 20 characters
   Company name   <== up to 40 characters
   Address 1      <== up to 30 characters, first line of address
   Address 2      <== up to 30 characters, 2nd line, if any, such as
                      'Suite 214'
   City           <== up to 30 characters
   State          <== two character state, if U.S.A.; else leave blank
   Zip            <== U.S.A. Zip code, 5 characters
   Zip4           <== U.S.A. Supplemental Zip code, 4 characters
   Phone          <== 13 character, if .U.S.A. or Canada. Must be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
   Comment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'
   Detail 1       <== up to 20 characters, placed into Patient Detail File,
                       field one.
   Detail 2       <== up to 20 characters
   Detail 3       <== up to 20 characters
   Detail 4       <== up to 20 characters
   Detail 5       <== up to 20 characters
   Detail 6       <== up to 20 characters
   Detail 7       <== up to 20 characters
   Detail 8       <== up to 20 characters
   Detail 9       <== up to 20 characters
   Detail 10      <== up to 20 characters
   Detail 11      <== up to 20 characters
   Detail 12      <== up to 20 characters


   Option  C will import from an ASCII file  named:  'AIMPORT.TXT'.   Make ì
   sure that your file has that name.

   Observe below one record in the ASCII "comma delimited" format:


"Alyce","Fisher","P.O. BOX","2116 E. Arapaho","P.O. Box 3823","Richardson",è"TX","75081","0433","[phone]",
"they currently have an 8bit system, written in compiled",
"Mr.","DET1","DET2","DET3","DET4","DET5","DET6","DET7","DET8",
"DET9","DET10","DET11","DET12"


Observe that this record would normally be on one continuous line,  but  is ì
here broken into five lines only for purposes of showing you how it looks.



                               ==============
                               ⁿ  OPTIO╬ D║ |
                               ==============

                   D)  Output records to WordPerfect[TM]
            [outputs into a 20 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
       ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2,CATEGORY,PRIORITY,REFERBY
                             DATE,AMOUNT,TITLE

Thσá .S╞á filσá i≤ thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠á use≤á fo≥á mergσ ì
letters¼á  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼ anΣ eacΦ recorΣ i≤ ì
delimiteΣ witΦ CONTROL-E.]

Bσá surσ t∩ retrievσ thσ 'Secondar∙ Fileº int∩ WordPerfect¼á a⌠ whicΦá timσ ì
WordPerfec⌠ wil∞ inser⌠ it≤ printe≥ codes«  Then¼ whilσ insidσ WordPerfect¼ ì
savσá thσ filσ unde≥ tha⌠ samσ name«á  A⌠ thi≤ point¼á thσ 'Secondar∙ Fileº ì
wil∞ bσ usablσ fo≥ purpose≤ oµ mai∞ merging.

'DATEºá i≤ thσ datσ oµ origina∞ entr∙ int∩ thσ program«á  'AMOUNTºá i≤á thσ ì
revenue/expensσ item.

                           [Similar to option 3]



                               ==============
                               |  OPTION E: |
                               ==============

                       "E)  Dun's [TM] ASCII import"

Dun'≤á Marketinτá Service≤á [TM▌á offer≤ aεá outstandinτá databasσá inquir∙ ì
servicσá fo≥ sale≤ anΣ marketinτ professional≤ calleΣ Dun'≤á Direc⌠á Acces≤ ì
[TM]« Fo≥ morσ informatioε oε thei≥ offerings¼ pleasσ call:

Dun'≤ Marketinτ Services
Threσ Sylvaε Way
Parsippany¼ N╩  0705┤  -3896

[phone]
(201)605-642┤
è

Iµá yo⌡á havσá an∙á question≤á abou⌠ Dun'≤á Translato≥á o≥á havσá technica∞ ì
questions¼á pleasσ cal∞ thσ Duε ª Bradstree⌠ Custome≥ Suppor⌠ Cente≥ a⌠á 1-ì
800-526-4590.

(201-464-780│ iε Ne≈ Jersey).


Thσá followinτá filσá format≤á arσ availablσ withiεá Dun'≤á Direc⌠á Access¼ ì
Versioε 3.0:


ABL│ 192 - Dun's Mailing Record
ABL│ 204 - Personalized DDM - One Name
ABL│ 260 - Dun's Telemarketing File
ABL│ 560 - Dun's Market Identifiers (DMI)
ACT│ 576 - Dun's Market Identifiers - Personalized
ACT│ 616 - Dun's Market Identifiers w/Trends Enhanced
───│ 706 - Dun's Market Identifiers w/AOS Enhanced
ABL│ 1129 - Enhanced Dun's Market Identifiers (EDMI)
ABL│ 1181 - EDMI Personalized Name
ABL│ 1331 - Enhanced Dun's Market Identifiers Plus
ABL│ 1383 - EDMI Plus Personalized Name
ACT│ 1782 - Dun's Executive Marketing Summaries (DEMS)
ACT│ 3062 - Dun's Executive Marketing Summaries (DEMS)
───│ 1918 - Dun's Executive Marketing Summaries (DEMS)
ABL│ 501 - International Dun's Market Identifiers
ABL│ 450 - Million Dollar File
ABL│ 450 - Metalworking File
ABL│ 536 - Asset Based Lending Master File
ACT│ 295 - Asset Based Lending Filings File
ACT│ 141 - Asset Based Lending Filings File
───│ 178 - Trinc Mailing File
ABL│ 266 - Trinc Mailing File
ABL│ 375 - Trinc Owner & User File
ABL│ 447 - Trinc File w/Personalization
ABL│ 589 - Trinc Full File
ACT│ 139 - Erisa Red (Pension Plans)
ACT│ 210 - Erisa Red (Pension Plans)
───│ 530 - Erisa Selling File
ABL│ 245 - Keogh
ABL│ 200 - MAP File
ABL│ 215 - MAP File
ABL│ 332 - MAP File
ACT│ 201 - UCC Mailing Label Record file
ACT│ 768 - UCC 768 file
───│ 640 - UCC Construction Equipment
ABL│ 640 - UCC Standard Office Products
ABL│ 768 - UCC Standard Office Products
ABL│ 840 - UCC 840 file
ABL│ 830 - UCC 830 Office Products file
ACT│ 522 - Metalworking - Personalized
ACT│ 660 - International Corporate Affiliations
───│ 530 - Broker's Ally                               è
T∩ impor⌠ datß int∩ thi≤ program¼á pleasσ selec⌠ thσ 57╢ characte≥ StandarΣ ì
DM╔ record:

            ACT│ 576 - Dun's Market Identifiers - Personalized




Dun'≤ [TM▌ output≤ it≤ field≤ iε thi≤ form:



1.DUNS Number
2.Business Name
3.Secondary Trade Name
4.Street Address
5.City
6.State
7.Physical Zip Code
8.Mailing Address
9.Mailing City
10.Mailing State
11.Mailing Zip Code
12.Carrier Route Code
13.Package Level Code
14.Geo  Codes D&B/FIPS
15.National Code
16.State Code
17.County Code
18.City Code/MSA Code
19.SMSA Code
20.Telephone Area Code
21.Telephone Number
22.Full Telephone Number
23.Full Exec Name
24.First Name
25.Middle Initial
26.Last Name
27.Suffix
28.Prefix
29.Title
30.MRC
31.Sales Volume
32.Code for EST/Range
33.Employees Total
34.Code for ACT/Range
35.Employees Here
36.Code for ACT/Range
37.Year Started
38.Status Indicator
39.Subsidiary Indicator
40.Manufacturing Indic
41.Ultimate DUNS
42.Headquarters DUNS    è43.Parent DUNS
44.Headquarters City
45.Headquarters State
46.Foreign Ult. DUNS
47.Foreign Parent DUNS
48.Hierarchy Code
49.DIAS Code
50.Population Code
51.Transaction Code
52.Report Date
53.User Area
54.Record Class Type
55.Line of Business
56.SIC Code 1
57.SIC Code 2
58.SIC Code 3
59.SIC Code 4
60.SIC Code 5
61.SIC Code 6
62.NULL
63.Last Item



T∩á seσá aε actua∞ examplσ oµ thei≥ data¼á observσ 'SAMPLDUN.TXTºá iεá thi≤ ì
subdirectory«  A≤ yo⌡ exi⌠ thi≤ program¼ pleasσ invoke:

             LIS╘ SAMPLDUN.TX╘  <============╜  Yo⌡ ente≥ this


ááá
Dun'≤á [TM▌á anΣá Dun'≤á Direc⌠ Acces≤ [TM▌ arσ trademark≤á oµá Thσá Duεá ª
Bradstree⌠á Corporation«á  Al∞ samplσ datß containeΣ iεá 'SAMPLDUN.TXTºá i≤ ì
propert∙ oµ Thσ Duε ª Bradstree⌠ Corporation.